SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspPurchase_UPDATE
(
@purchaseId int = null,
@orderId int = null,
@productId int = null,
@quantity int = null,
@createdDate datetime = null,
@lastModifiedDate datetime = null,
@isDeleted bit = null
)
AS

UPDATE
  [dbo].[Purchase]
SET
  [OrderId] = @orderId,
  [ProductId] = @productId,
  [Quantity] = @quantity,
  [CreatedDate] = @createdDate,
  [LastModifiedDate] = @lastModifiedDate,
  [IsDeleted] = @isDeleted
WHERE
  [PurchaseId] = @purchaseId


GO
